query($DB, $sSQL);
$aryRow=$q->getrow();
if(isset($aryRow['max_id'])){
$max_id=$aryRow['max_id'];
$$new_cookie=$max_id;
SetCookie($new_cookie,$$new_cookie,time()+ 31536000);
SetCookie($haveread_cookie,$$new_cookie,time()+ 31536000,"/","www.nanya.ru"); //destroy session cookie
unset($$haveread_cookie);
}
}
if(!IsSet($$new_cookie)){
$$new_cookie='0';
}
$use_haveread=false;
if(IsSet($$haveread_cookie)) {
$arr=explode(".", $$haveread_cookie);
$old_message=reset($arr);
array_walk($arr, "explode_haveread");
$use_haveread=true;
}
else{
$old_message=$$new_cookie;
}
if(IsSet($collapse)){
$$phcollapse=$collapse;
SetCookie("phorum-collapse-$ForumTableName",$collapse,time()+ 31536000);
}
elseif(!isset($$phcollapse)){
$$phcollapse=$ForumCollapse;
}
}
else{
if(IsSet($collapse)){
$$phcollapse=$collapse;
}
else{
$$phcollapse=$ForumCollapse;
}
}
if($DB->type=="sybase") {
$limit="";
$q->query($DB, "set rowcount $ForumDisplay");
}
elseif($DB->type=="postgresql"){
$limit="";
$q->query($DB, "set QUERY_LIMIT TO '$ForumDisplay'");
}
else{
$limit=" limit $ForumDisplay";
}
//added start
$whereclause = "";
if ($ForumModeration!='n') {
$whereclause = " WHERE approved='Y'";
}
if ($$phcollapse==1) {
if ($thread!=0) {
$myflag = " datestamp < '$thread'";
if($action==1){
if (!empty($whereclause)) {
$tempwhere = $whereclause." AND datestamp > '$thread'";
} else {
$tempwhere = " WHERE datestamp >= '$thread'";
}
$sSQL = "Select datestamp as maxtime from $ForumTableName".$tempwhere." ORDER BY datestamp DESC".$limit;
$q->query($DB, $sSQL);
if($q->numrows()>0){
$rec=$q->getrow();
if (isset($rec["maxtime"])) {
$myflag = " datestamp <= '".$rec["maxtime"]."'";
}
}
}
if (empty($whereclause)) {
$whereclause = " WHERE".$myflag;
} else {
$whereclause .= " AND".$myflag;
}
}
if($$phcollapse==0){
$sSQL = "SELECT thread, datestamp FROM $ForumTableName".$whereclause." GROUP BY thread ORDER BY datestamp desc".$limit;
} else {
$sSQL = "SELECT thread, datestamp, count(id) AS tcount, datestamp AS latest, max(id) as maxid FROM $ForumTableName".$whereclause." GROUP BY thread ORDER BY datestamp desc".$limit;
}
// print $sSQL;
$thread_list = new query($DB, $sSQL);
if($DB->type=="sybase") {
$q->query($DB, "set rowcount 0");
}
elseif($DB->type=="postgresql"){
$q->query($DB, "set QUERY_LIMIT TO '0'");
}
$rec=$thread_list->getrow();
if(empty($rec["thread"]) && $action!=0){
Header("Location: $forum_url/$list_page.$ext?f=$num$GetVars");
exit();
}
$aryThreadstring=array();
$threads=array();
$max=0;
$min=0;
while (is_array($rec)){
if($rec["datestamp"]>$max) {
$max=$rec["datestamp"];
if($min==0) {
$min=$max;
}
} elseif ($rec["datestamp"]<$min) {
$min=$rec["datestamp"];
}
$aryThreadstring[$rec["thread"]] = $rec["thread"];
$threads[]=$rec;
$rec=$thread_list->getrow();
}
$threadstring = implode(",",$aryThreadstring);
if (empty($threadstring)) {
$headers=array();
} else {
$whereclause = "";
if ($ForumModeration!='n') {
$whereclause = " WHERE approved='Y'";
}
$threadwhere = " thread IN (".$threadstring.")";
if (empty($whereclause)) {
$whereclause = " WHERE".$threadwhere;
} else {
$whereclause .= " AND".$threadwhere;
}
if($$phcollapse==0){
$sSQL = "Select id,parent,thread,subject,author,datestamp from $ForumTableName".$whereclause." order by datestamp desc, id asc";
} else {
if (empty($whereclause)) {
$whereclause = " WHERE parent = 0";
} else {
$whereclause .= " AND parent = 0";
}
$sSQL = "Select id,0 as parent,thread,subject,author,datestamp from $ForumTableName".$whereclause." order by datestamp desc";
}
$msg_list = new query($DB, $sSQL);
$rec=$msg_list->getrow();
$headers = array();
while(is_array($rec)){
$headers[]=$rec;
$rec=$msg_list->getrow();
}
}
$rows=@count($headers);
} else {
if($thread==0 || $action==0){
$sSQL = "Select max(thread) as thread from $ForumTableName where approved='Y'";
$q->query($DB, $sSQL);
if($q->numrows()>0){
$rec=$q->getrow();
$maxthread = isset($rec["thread"]) ? $rec["thread"] : 0;
}
else{
$maxthread=0;
}
if ($maxthread > $cutoff) {
$cutoff_thread=$maxthread-$cutoff;
} else {
$cutoff_thread = 0;
}
if($$phcollapse==0){
$sSQL = "Select thread from $ForumTableName where thread > '$cutoff_thread' and approved='Y' order by thread desc".$limit;
}
else{
$sSQL = "Select thread, count(id) as tcount, max(datestamp) as latest, max(id) as maxid from $ForumTableName where approved='Y' AND thread > '$cutoff_thread' group by thread order by thread desc".$limit;
}
}
else{
if($action==1){
$cutoff_thread=$thread+$cutoff;
if($$phcollapse==0){
$sSQL = "Select thread from $ForumTableName where approved='Y' AND thread < '$cutoff_thread' AND thread > '$thread' order by thread".$limit;
}
else{
$sSQL = "Select thread from $ForumTableName where thread=id AND approved='Y' AND thread < '$cutoff_thread' AND thread > '$thread' order by thread".$limit;
}
$q=new query($DB, $sSQL);
$rec=$q->getrow();
if(!empty($rec["thread"])){
$keepgoing=true;
$x=0;
while (is_array($rec) && $keepgoing){
$thread = $rec["thread"];
$rec=$q->getrow();
$x++;
}
}
$thread=$thread+1;
}
if ($thread > $cutoff) {
$cutoff_thread=$thread-$cutoff;
} else {
$cutoff_thread = 0;
}
if($$phcollapse==0){
$sSQL = "Select thread from $ForumTableName where approved='Y' and thread < '$thread' and thread > '$cutoff_thread' order by thread desc".$limit;
}
else{
$sSQL = "Select thread, COUNT(id) AS tcount, MAX(datestamp) AS latest, MAX(id) AS maxid FROM $ForumTableName WHERE approved='Y' AND thread < '$thread' AND thread > '$cutoff_thread' GROUP BY thread ORDER BY thread DESC".$limit;
}
}
$thread_list = new query($DB, $sSQL);
if($DB->type=="sybase") {
$q->query($DB, "set rowcount 0");
}
elseif($DB->type=="postgresql"){
$q->query($DB, "set QUERY_LIMIT TO '0'");
}
$rec=$thread_list->getrow();
if(empty($rec["thread"]) && $action!=0){
Header("Location: $forum_url/$list_page.$ext?f=$num$GetVars");
exit();
}
if(isset($rec['thread'])){
$max=$rec["thread"];
$keepgoing=true;
$x=0;
while (is_array($rec)){
$threads[]=$rec;
$min=$rec["thread"];
$rec=$thread_list->getrow();
}
}
else{
$threads="";
$max=0;
$min=0;
}
if($$phcollapse==0){
$sSQL = "Select id,parent,thread,subject,author,datestamp from $ForumTableName where approved='Y' AND thread<=$max and thread>=$min order by thread desc, id asc";
}
else{
$sSQL = "Select id,thread,subject,author,datestamp from $ForumTableName where approved='Y' AND thread = id AND thread<=$max AND thread>=$min order by thread desc";
}
$msg_list = new query($DB, $sSQL);
$rec=$msg_list->getrow();
while(is_array($rec)){
$headers[]=$rec;
$rec=$msg_list->getrow();
}
$rows=@count($headers);
}
// added end
if(file_exists("$include_path/header_$ForumConfigSuffix.php")){
include "$include_path/header_$ForumConfigSuffix.php";
}
else{
include "$include_path/header.php";
}
if($$phcollapse==0){
$collapse_link = "".$lCollapseThreads."";
}
else{
$collapse_link = "".$lViewThreads."";
}
if($ActiveForums>1){
$nav = "";
// $nav = "";
}
else{
$nav = "";
}
$pagenav="";
if($$phcollapse==1){
// print "min: $min, max: $max";
$min=rawurlencode($min);
$max=rawurlencode($max);
}
if($action!=0) $pagenav=" $lNewerMessages";
if($rows>=$ForumDisplay){
if(!empty($pagenav)) $pagenav.=" | ";
$pagenav.="$lOlderMessages ";
}
if(empty($pagenav)) {
$pagenav=" ";
}
// print "";
// while (list($k,$v)=each($headers)){
// list ($t1,$t2)=each($threads);
// print "$k - $v: $t1 - $t2 ";
// print "$k - $v: $t1 - $t2";
// while(list($k2,$v2)=each($t2)){
// print "$k2 |";
// }
// print "
\n";
// }
// print "";
?>